Report GLO AnaCredit

omc0034 - each entity type omc0034 row count check

Card of business rule each entity type omc0034 row count check

Name	each entity type omc0034 row count check
Code	omc0034
Comment	Let the set S contain each entity type where it is true that the value of 'rowcount reporting indicator' = "entity type with reported rowcount". For each entity type E in set S, the total number of rows of E must correspond to the value of the attribute 'rowcount' in the entity type 'entity type delivery' for E.
Rule Type	Constraint

Server expression of the business rule each entity type omc0034 row count check

For each entity type E in AnaCredit GLO where 'E'.'rowcount reporting indicator' = "entity type with reported rowcount":
select case when count(1) = rowcount then true else false end as validation
from 'check entiteit', 'entity type delivery'
where 'entity type delivery'.'entity type code' = E
group by rowcount;

List of DNB-specific attributes of the business rule each entity type omc0034 row count check

business rule classification

other model constraint

business rule scope

Checked within the data delivery

business rule status

active business rule

number of dependencies

severity

signalling

List of attached objects of the business rule each entity type omc0034 row count check

Logical Data Model 'AnaCredit GLO per bank LDM'

Home